-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Окт 21 2013 г., 11:17
-- Версия сервера: 5.5.32-log
-- Версия PHP: 5.3.26




--
-- База данных: `db`
--

-- --------------------------------------------------------

--
-- Структура таблицы `ratings`
--

CREATE TABLE IF NOT EXISTS `ratings` (
  `id` varchar(255) NOT NULL,
  `total_votes` int(11) NOT NULL DEFAULT '0',
  `total_value` int(11) NOT NULL DEFAULT '0',
  `used_ips` longtext,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `ratings`
--

INSERT INTO `ratings` (`id`, `total_votes`, `total_value`, `used_ips`) VALUES
('/catalog/item/198', 1, 5, 'a:1:{i:0;s:12:"93.81.81.213";}'),
('/catalog/item/208', 1, 5, 'a:1:{i:0;s:12:"93.81.81.213";}'),
('/catalog/item/209', 1, 5, 'a:1:{i:0;s:12:"93.81.81.213";}'),
('/catalog/item/201', 1, 5, 'a:1:{i:0;s:12:"78.106.58.47";}'),
('/catalog/item/194', 0, 0, ''),
('/catalog/item/204', 1, 5, 'a:1:{i:0;s:12:"93.81.81.213";}'),
('/catalog/item/203', 2, 10, 'a:2:{i:0;s:12:"93.81.81.213";i:1;s:12:"78.106.58.47";}'),
('/catalog/item/199', 0, 0, ''),
('/catalog/item/202', 2, 10, 'a:2:{i:0;s:12:"93.81.81.213";i:1;s:12:"78.106.58.47";}'),
('/catalog/item/200', 0, 0, ''),
('/catalog/item/212', 2, 10, 'a:2:{i:0;s:12:"78.106.58.47";i:1;s:12:"93.81.199.68";}'),
('/catalog/item/213', 0, 0, ''),
('/catalog/item/214', 1, 5, 'a:1:{i:0;s:12:"78.106.58.47";}'),
('/catalog/item/215', 1, 5, 'a:1:{i:0;s:12:"78.106.58.47";}'),
('/catalog/item/216', 1, 5, 'a:1:{i:0;s:12:"78.106.58.47";}'),
('/catalog/item/217', 1, 5, 'a:1:{i:0;s:12:"78.106.58.47";}'),
('/catalog/item/219', 1, 5, 'a:1:{i:0;s:12:"78.106.58.47";}'),
('/catalog/item/218', 1, 5, 'a:1:{i:0;s:12:"78.106.58.47";}'),
('/catalog/item/220', 1, 5, 'a:1:{i:0;s:12:"78.106.58.47";}'),
('/catalog/item/225', 0, 0, ''),
('/catalog/item/222', 1, 5, 'a:1:{i:0;s:13:"95.159.128.36";}'),
('/catalog/item/221', 0, 0, ''),
('/catalog/item/226', 0, 0, ''),
('/catalog/item/224', 0, 0, ''),
('/catalog/item/228', 0, 0, ''),
('/catalog/item/229', 0, 0, ''),
('/catalog/item/227', 0, 0, ''),
('/catalog/item/223', 1, 5, 'a:1:{i:0;s:14:"128.73.253.247";}'),
('/catalog/item/231', 0, 0, ''),
('/catalog/item/230', 0, 0, '');

-- --------------------------------------------------------

--
-- Структура таблицы `road2`
--

CREATE TABLE IF NOT EXISTS `road2` (
  `num` int(10) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` text COLLATE utf8_unicode_ci NOT NULL,
  `comm` text COLLATE utf8_unicode_ci NOT NULL,
  `data` datetime NOT NULL,
  `moder` int(1) NOT NULL,
  `ip` text COLLATE utf8_unicode_ci NOT NULL,
  `mail` text COLLATE utf8_unicode_ci NOT NULL,
  `rootid` int(11) NOT NULL,
  `level` int(11) NOT NULL DEFAULT '0',
  `raitng` int(11) NOT NULL DEFAULT '0',
  `iprating` text COLLATE utf8_unicode_ci NOT NULL,
  `http` text COLLATE utf8_unicode_ci NOT NULL,
  `service` text COLLATE utf8_unicode_ci NOT NULL,
  `avatar` text COLLATE utf8_unicode_ci NOT NULL,
  `admincom` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`num`),
  KEY `url` (`url`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;

--
-- Дамп данных таблицы `road2`
--

INSERT INTO `road2` (`num`, `url`, `name`, `comm`, `data`, `moder`, `ip`, `mail`, `rootid`, `level`, `raitng`, `iprating`, `http`, `service`, `avatar`, `admincom`) VALUES
(4, '/catalog/item/225', 'Наталья', 'Вкуснятина!', '2013-08-29 16:24:32', 0, '95.159.128.36', '', 0, 0, 1, '95.159.128.36|', '', '', '', 0),
(5, '/catalog/item/222', 'Dan', 'Выглядит очень аппетитно)', '2013-08-29 16:25:18', 0, '95.159.128.36', '', 0, 0, 0, '', '', '', '', 0);

-- --------------------------------------------------------

--
-- Структура таблицы `road_config`
--

CREATE TABLE IF NOT EXISTS `road_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `par` text COLLATE utf8_unicode_ci NOT NULL,
  `val` text COLLATE utf8_unicode_ci NOT NULL,
  `com` text COLLATE utf8_unicode_ci NOT NULL,
  `tmp` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=61 ;

--
-- Дамп данных таблицы `road_config`
--

INSERT INTO `road_config` (`id`, `par`, `val`, `com`, `tmp`) VALUES
(1, 'smile', '1', '', ''),
(2, 'bbpanel', '1', '', ''),
(3, 'linkbb', '1', '', ''),
(4, 'linknofol', '1', '', ''),
(5, 'linkredirect', '', '', ''),
(6, 'linkpars', '0', '', ''),
(7, 'picbb', '1', '', ''),
(8, 'picpars', '0', '', ''),
(9, 'quotebb', '0', '', ''),
(10, 'quotestyle', 'border: dotted #666 1px;border-left:solid #ff5a00 5px;margin:10px 10px;color:#333;font-style:italic;background:#fcfcfc;padding:15px;', '', ''),
(11, 'colorbb', '1', '', ''),
(12, 'sizebb', '1', '', ''),
(13, 'justbb', '1', '', ''),
(14, 'sumvl', '200', '', ''),
(15, 'sumvlname', '20', '', ''),
(16, 'wordcut', '50', '', ''),
(17, 'moder', '0', '', ''),
(18, 'http', '0', '', ''),
(19, 'mail', '0', '', ''),
(20, 'mailbox', 'mail@mail.ru', '', ''),
(21, 'viewentermail', '0', '', ''),
(22, 'replaymail', '0', '', ''),
(23, 'listz', '6', '', ''),
(24, 'sort', '1', '', ''),
(25, 'nameadmin', 'DEMOAdmin', '', ''),
(26, 'formatdate', 'Y-m-d H:i:s', '', ''),
(27, 'correcttime', '+0 hours', '', ''),
(28, 'specurl', '', '', ''),
(29, 'hideaddform', '1', '', ''),
(30, 'autosize', '1', '', ''),
(31, 'useravatar', '0', '', ''),
(32, 'workcapt', '1', '', ''),
(33, 'maxlevel', '5', '', ''),
(34, 'pxlevel', '20', '', ''),
(35, 'startpx', '5', '', ''),
(36, 'lastcomment', '5', '', ''),
(37, 'lastsum', '5', '', ''),
(38, 'lastend', '...', '', ''),
(39, 'rss', '1', '', ''),
(40, 'titlecia', 'CommentIt 5 Ajax', '', ''),
(41, 'descriptioncia', 'Comment in you site', '', ''),
(42, 'yaping', '0', '', ''),
(43, 'europing', '0', '', ''),
(44, 'antimat', '0', '', ''),
(45, 'antilevel', '1', '', ''),
(46, 'antislovo', '<censor>', '', ''),
(47, 'rating', '1', '', ''),
(48, 'ratingadmin', '1', '', ''),
(49, 'loginzaglob', '0', '', ''),
(50, 'yandex', '0', '', ''),
(51, 'google', '0', '', ''),
(52, 'vkontakte', '1', '', ''),
(53, 'mailru', '1', '', ''),
(54, 'twitter', '0', '', ''),
(55, 'loginza', '1', '', ''),
(56, 'myopenid', '0', '', ''),
(57, 'openid', '0', '', ''),
(58, 'webmoney', '0', '', ''),
(59, 'loginzavatar', '0', '', ''),
(60, 'loginzurl', '0', '', '');

-- --------------------------------------------------------

--
-- Структура таблицы `_menu`
--

CREATE TABLE IF NOT EXISTS `_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `position` smallint(3) NOT NULL,
  `disabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `disabled` (`disabled`),
  KEY `parent_id` (`parent_id`),
  KEY `position` (`position`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=17 ;

--
-- Дамп данных таблицы `_menu`
--

INSERT INTO `_menu` (`id`, `parent_id`, `title`, `link`, `position`, `disabled`) VALUES
(5, 0, 'Каталог', './', 6, 0),
(7, 0, 'Контакты', 'contact', 1, 0),
(10, 0, 'Отзывы', 'testimonials', 2, 0);

-- --------------------------------------------------------

--
-- Структура таблицы `_orders`
--

CREATE TABLE IF NOT EXISTS `_orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` int(11) NOT NULL,
  `cart` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  `paymethod` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(11) NOT NULL,
  `date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `step` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=44 ;

-- --------------------------------------------------------

--
-- Структура таблицы `_pano`
--

CREATE TABLE IF NOT EXISTS `_pano` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(11) NOT NULL,
  `position` smallint(3) NOT NULL,
  `disabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `position` (`position`),
  KEY `disabled` (`disabled`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `_products`
--

CREATE TABLE IF NOT EXISTS `_products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `price` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `price_old` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `brief` text COLLATE utf8_unicode_ci NOT NULL,
  `description_wiki` text COLLATE utf8_unicode_ci NOT NULL,
  `description_html` text COLLATE utf8_unicode_ci NOT NULL,
  `seotext_wiki` text COLLATE utf8_unicode_ci NOT NULL,
  `seotext_html` text COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(11) NOT NULL,
  `picture` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `album` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `label` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
  `also` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `position` smallint(3) NOT NULL,
  `position_main` smallint(3) NOT NULL,
  `main` tinyint(1) NOT NULL,
  `disabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `disabled` (`disabled`),
  KEY `timestamp` (`timestamp`),
  KEY `position` (`position`),
  KEY `category_id` (`category_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=232 ;

--
-- Дамп данных таблицы `_products`
--

INSERT INTO `_products` (`id`, `category_id`, `name`, `price`, `price_old`, `brief`, `description_wiki`, `description_html`, `seotext_wiki`, `seotext_html`, `title`, `keywords`, `description`, `timestamp`, `picture`, `album`, `label`, `also`, `position`, `position_main`, `main`, `disabled`) VALUES
(221, 0, 'Супер Пепперони', '480', '', 'соус «Сити Пицца», сыр «Моцарелла», колбаса «Пепперони»', 'соус «Сити Пицца», сыр «Моцарелла», колбаса «Пепперони»', '<p>соус &laquo;Сити Пицца&raquo;, сыр &laquo;Моцарелла&raquo;, колбаса &laquo;Пепперони&raquo;</p>', '', '', '', '', '', 0, '221751a5.png', '', 'hit', '', 999, 0, 1, 0),
(222, 0, 'С тигровыми креветками', '740', '', 'соус «Сити Пицца», сыр «Моцарелла», тигровые креветки, помидоры, салат "Руккола", соус "Песто"', 'соус «Сити Пицца», сыр «Моцарелла», тигровые креветки, помидоры, салат "Руккола", соус "Песто"', '<p>соус &laquo;Сити Пицца&raquo;, сыр &laquo;Моцарелла&raquo;, тигровые креветки, помидоры, салат &quot;Руккола&quot;, соус &quot;Песто&quot;</p>', '', '', '', '', '', 0, '222119c4.png', '', 'new', '', 999, 0, 1, 0),
(223, 0, 'Гавайская с креветками', '600', '', 'соус «Сити Пицца», сыр «Моцарелла», креветки, ананасы консервированные', 'соус «Сити Пицца», сыр «Моцарелла», креветки, ананасы консервированные', '<p>соус &laquo;Сити Пицца&raquo;, сыр &laquo;Моцарелла&raquo;, креветки, ананасы консервированные</p>', '', '', '', '', '', 0, '223d5e61.png', '', 'new', '', 999, 0, 1, 0),
(224, 0, 'Четыре сыра', '550', '', 'соус «Сити Пицца», сыр «Моцарелла», сыр «Дор-Блю», сыр «Мимолет», сыр «Чеддер»', 'соус «Сити Пицца», сыр «Моцарелла», сыр «Дор-Блю», сыр «Мимолет», сыр «Чеддер»', '<p>соус &laquo;Сити Пицца&raquo;, сыр &laquo;Моцарелла&raquo;, сыр &laquo;Дор-Блю&raquo;, сыр &laquo;Мимолет&raquo;, сыр &laquo;Чеддер&raquo;</p>', '', '', '', '', '', 0, '224c02bb.png', '', '', '', 999, 0, 1, 0),
(225, 0, 'Барбекю', '480', '580', 'соус «Сити Пицца», сыр «Моцарелла», куриные грудки в соусе «Барбекю»', 'соус «Сити Пицца», сыр «Моцарелла», куриные грудки в соусе «Барбекю»', '<p>соус &laquo;Сити Пицца&raquo;, сыр &laquo;Моцарелла&raquo;, куриные грудки в соусе &laquo;Барбекю&raquo;</p>', '', '', '', '', '', 0, '2257ad5b.png', '', 'promo', '', 999, 0, 1, 0),
(226, 0, 'Си Фуд', '500', '680', 'соус «Си Фуд», сыр «Моцарелла», морепродукты, маслины, сладкий перец', 'соус «Си Фуд», сыр «Моцарелла», морепродукты, маслины, сладкий перец', '<p>соус &laquo;Си Фуд&raquo;, сыр &laquo;Моцарелла&raquo;, морепродукты, маслины, сладкий перец</p>', '', '', '', '', '', 0, '22675f3f.png', '', 'discount', '', 999, 0, 1, 0),
(227, 0, 'Маргарита', '350', '', 'соус «Сити Пицца», сыр «Моцарелла»', 'соус «Сити Пицца», сыр «Моцарелла»', '<p>соус &laquo;Сити Пицца&raquo;, сыр &laquo;Моцарелла&raquo;</p>', '', '', '', '', '', 0, '227ae97e.png', '', 'hit', '', 999, 0, 1, 0),
(228, 0, 'Салями', '430', '', 'соус «Сити Пицца», сыр «Моцарелла», колбаса «Салями»', 'соус «Сити Пицца», сыр «Моцарелла», колбаса «Салями»', '<p>соус &laquo;Сити Пицца&raquo;, сыр &laquo;Моцарелла&raquo;, колбаса &laquo;Салями&raquo;</p>', '', '', '', '', '', 0, '228bb49b.png', '', '', '', 999, 0, 1, 0),
(229, 0, 'Coca-Cola 0,5', '50', '', '', '', '', '', '', '', '', '', 0, '2295154b.png', '', 'hit', '', 999, 0, 1, 0),
(230, 0, 'Fanta 0,5', '50', '', '', '', '', '', '', '', '', '', 0, '230af52f.png', '', '', '', 999, 0, 0, 0),
(231, 0, 'Sprite 0,5', '50', '', '', '', '', '', '', '', '', '', 0, '231046ce.png', '', '', '', 999, 0, 0, 0);

-- --------------------------------------------------------

--
-- Структура таблицы `_product_structure`
--

CREATE TABLE IF NOT EXISTS `_product_structure` (
  `product_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Дамп данных таблицы `_product_structure`
--

INSERT INTO `_product_structure` (`product_id`, `category_id`) VALUES
(12, 8),
(12, 6),
(12, 4),
(17, 7),
(18, 12),
(18, 5),
(19, 12),
(20, 11),
(19, 6),
(20, 6),
(21, 12),
(21, 6),
(22, 12),
(22, 6),
(23, 12),
(23, 6),
(24, 12),
(24, 6),
(25, 12),
(25, 6),
(26, 12),
(26, 6),
(27, 5),
(28, 5),
(29, 5),
(30, 5),
(31, 5),
(32, 5),
(33, 5),
(34, 5),
(35, 6),
(36, 6),
(37, 6),
(38, 5),
(39, 6),
(40, 6),
(41, 6),
(42, 6),
(43, 6),
(44, 6),
(45, 6),
(46, 6),
(47, 6),
(48, 12),
(48, 10),
(48, 6),
(49, 12),
(49, 10),
(49, 6),
(50, 12),
(50, 10),
(50, 6),
(51, 12),
(51, 10),
(51, 5),
(52, 12),
(52, 10),
(52, 5),
(53, 12),
(53, 10),
(53, 5),
(54, 9),
(55, 9),
(56, 9),
(57, 9),
(58, 9),
(59, 6),
(59, 9),
(60, 6),
(60, 9),
(61, 6),
(61, 9),
(62, 7),
(62, 9),
(63, 7),
(63, 9),
(64, 7),
(64, 9),
(65, 6),
(65, 12),
(66, 14),
(67, 6),
(67, 14),
(68, 6),
(68, 14),
(69, 6),
(69, 14),
(70, 6),
(70, 14),
(71, 14),
(71, 6),
(72, 12),
(72, 14),
(72, 6),
(73, 5),
(73, 14),
(74, 6),
(74, 14),
(75, 7),
(75, 14),
(76, 6),
(76, 14),
(77, 6),
(77, 14),
(78, 6),
(79, 12),
(79, 6),
(80, 12),
(80, 6),
(81, 6),
(82, 6),
(83, 12),
(83, 6),
(84, 6),
(85, 6),
(86, 6),
(86, 10),
(87, 6),
(88, 12),
(88, 5),
(89, 12),
(89, 5),
(90, 12),
(90, 5),
(91, 5),
(91, 12),
(92, 5),
(92, 12),
(93, 5),
(94, 5),
(95, 5),
(96, 5),
(97, 5),
(98, 5),
(98, 10),
(95, 10),
(94, 10),
(93, 10),
(97, 10),
(99, 5),
(99, 10),
(100, 6),
(100, 10),
(101, 6),
(101, 10),
(102, 5),
(102, 10),
(103, 6),
(104, 6),
(105, 6),
(106, 12),
(106, 6),
(107, 6),
(107, 12),
(107, 11),
(108, 6),
(108, 12),
(109, 6),
(110, 6),
(111, 6),
(112, 6),
(113, 6),
(114, 6),
(114, 12),
(115, 6),
(116, 6),
(116, 10),
(116, 12),
(117, 6),
(118, 5),
(119, 5),
(120, 6),
(121, 6),
(121, 12),
(122, 12),
(122, 6),
(123, 12),
(124, 12),
(125, 6),
(125, 12),
(126, 6),
(126, 12),
(127, 5),
(127, 12),
(128, 6),
(128, 12),
(129, 5),
(129, 12),
(130, 6),
(130, 12),
(131, 6),
(132, 6),
(133, 7),
(134, 6),
(134, 12),
(135, 6),
(135, 12),
(136, 5),
(136, 10),
(137, 10),
(137, 6),
(138, 10),
(138, 6),
(139, 6),
(139, 10),
(140, 6),
(140, 10),
(141, 6),
(141, 10),
(142, 6),
(142, 10),
(143, 6),
(143, 10),
(144, 6),
(144, 10),
(145, 6),
(145, 10),
(146, 6),
(146, 10),
(147, 6),
(147, 10),
(148, 6),
(148, 7),
(148, 10),
(149, 5),
(150, 7),
(151, 6),
(152, 6),
(153, 6),
(153, 10),
(154, 6),
(155, 6),
(156, 6),
(157, 7),
(158, 5),
(159, 6),
(160, 6),
(161, 6),
(162, 6),
(163, 6),
(164, 6),
(165, 6),
(166, 5),
(167, 5),
(168, 5),
(169, 12),
(169, 5),
(170, 6),
(171, 5),
(172, 5),
(173, 6),
(174, 6),
(175, 6),
(176, 5),
(177, 6),
(178, 6),
(179, 6),
(180, 0),
(181, 6),
(182, 6),
(182, 12),
(183, 6),
(183, 12),
(184, 5),
(186, 0),
(187, 15),
(188, 15),
(189, 0),
(192, 16),
(193, 18),
(194, 17),
(195, 18),
(196, 18),
(191, 18),
(197, 18),
(198, 18),
(199, 19),
(200, 19),
(201, 19),
(201, 17),
(200, 17),
(199, 17),
(198, 19),
(202, 17),
(202, 19),
(203, 17),
(203, 19),
(204, 17),
(204, 19),
(210, 18),
(205, 17),
(206, 17),
(206, 19),
(207, 20),
(207, 18),
(193, 20),
(207, 19),
(208, 17),
(208, 19),
(209, 18),
(209, 19),
(210, 19),
(211, 19),
(212, 22),
(213, 23),
(214, 24),
(215, 27),
(216, 27),
(217, 27),
(218, 32),
(219, 32),
(220, 32),
(221, 40),
(222, 40),
(223, 40),
(224, 40),
(225, 40),
(226, 40),
(227, 40),
(228, 40),
(229, 41),
(230, 41),
(231, 41);

-- --------------------------------------------------------

--
-- Структура таблицы `_testimonials`
--

CREATE TABLE IF NOT EXISTS `_testimonials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `duties` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `website` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(11) NOT NULL,
  `picture` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `position` smallint(3) NOT NULL,
  `disabled` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `position` (`position`),
  KEY `disabled` (`disabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=34 ;

--
-- Дамп данных таблицы `_testimonials`
--

INSERT INTO `_testimonials` (`id`, `name`, `phone`, `city`, `duties`, `website`, `message`, `timestamp`, `picture`, `position`, `disabled`) VALUES
(26, 'Екатерина', '', 'Южно-Сахалинск', 'Студентка', '', 'Самая вкусная пицца в городе у ВАС!', 1352304471, '26958ea.jpg', 2, 0),
(27, 'Виктор', '', 'Ю-С', 'Менеджер', '', 'Заказали пиццу на обед, привезли все вовремя, спасибо, очень вкусно, с коллегами съели моментально)', 1360091213, '2732743.jpg', 3, 0),
(33, 'Руслан', '', 'Ю-С', 'Директор', '', 'Ваша пицца это лучший друг для холостяка :)', 1372157096, '338a9fb.jpg', 0, 0);

-- --------------------------------------------------------

--
-- Структура таблицы `_themes`
--

CREATE TABLE IF NOT EXISTS `_themes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `settings` text COLLATE utf8_unicode_ci NOT NULL,
  `author` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `picture` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Дамп данных таблицы `_themes`
--

INSERT INTO `_themes` (`id`, `name`, `description`, `settings`, `author`, `picture`) VALUES
(4, 'Стандартная', 'Тема оформления по умолчанию', '{"body_bg_color":"#E7DECD","body_bg_image":"","body_bg_pattern":"4ead34.png","body_pattern_fixed":null,"body_bg_fixed":"0","menu_link_color":"#222222","menu_bg_color":"0","menu_bg_opacity":"0.3","text_color":"#575757","header_color":"#000000","price_color":"#222222","block_bg_color":"#ffffff","phone_color":"#000000","link_color":"#222222","foot_bg_color":"#ffffff","foot_font_color":"#222222","foot_link_color":"#222222","button_bg_color":"#B01A33","button2_bg_color":"#CECECE","button_font_color":"#ffffff","button2_font_color":"#222222"}', '', '691844.jpg'),
(7, 'Gren', 'Зеленая тема оформления', '{"body_bg_color":"#ffffff","body_bg_image":"bg51d547.png","body_bg_pattern":"pattern51d547.png","body_pattern_fixed":"1","body_bg_fixed":"1","menu_link_color":"#222222","menu_bg_color":"1","menu_bg_opacity":"0.1","text_color":"#575757","header_color":"#000000","price_color":"#222222","block_bg_color":"#ffffff","phone_color":"#000000","link_color":"#222222","foot_bg_color":"#CECECE","foot_font_color":"#222222","foot_link_color":"#222222","button_bg_color":"#B01A33","button2_bg_color":"#CECECE","button_font_color":"#ffffff","button2_font_color":"#000000"}', '', '51d547.jpg');

